<?xml version='1.0' encoding='UTF-8'?>
<data>
  <AD_REF_TABLE AD_REFERENCE_ID="232" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-04-24 21:52:32.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="(C_BPartner.IsSalesRep='Y' OR C_BPartner.IsVendor='Y')" ORDERBYCLAUSE="C_BPartner.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="233" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-04-26 19:45:54.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="145" AD_KEY="837" AD_DISPLAY="482" ISVALUEDISPLAYED="N" WHERECLAUSE="EXISTS (SELECT * FROM C_PeriodControl pc WHERE C_Period.C_Period_ID=pc.C_Period_ID AND pc.PeriodStatus='O')" ORDERBYCLAUSE="C_Period.StartDate" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="239" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-05-13 10:07:57.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="446" AD_KEY="5999" AD_DISPLAY="6008" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="240" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-05-13 10:18:21.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="448" AD_KEY="6045" AD_DISPLAY="6054" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="242" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-05-13 10:46:26.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="448" AD_KEY="6045" AD_DISPLAY="6054" ISVALUEDISPLAYED="N" WHERECLAUSE="PA_ReportLine.IsSummary='Y' " ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="244" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-09-08 14:15:42.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="101" AD_KEY="109" AD_DISPLAY="116" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Column.IsKey='Y'" ORDERBYCLAUSE="AD_Column.ColumnName" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="249" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-01-21 21:20:18.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="475" AD_KEY="6581" AD_DISPLAY="6589" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="251" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-05-26 10:50:52.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="101" AD_KEY="109" AD_DISPLAY="111" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_Column.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="252" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-06-22 19:22:08.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsEmployee='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="400" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-02-27 00:00:00.0" CREATEDBY="0" UPDATED="2007-02-27 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="284" AD_KEY="2801" AD_DISPLAY="2809" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Process.JasperReport IS NOT NULL" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="257" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-07-11 21:29:49.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="101" AD_KEY="109" AD_DISPLAY="111" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Column.AD_Reference_ID=11" ORDERBYCLAUSE="AD_Column.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="258" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-07-11 21:32:36.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="101" AD_KEY="109" AD_DISPLAY="111" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Column.AD_Reference_ID=20" ORDERBYCLAUSE="AD_Column.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="259" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-07-11 21:41:19.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="493" AD_KEY="7026" AD_DISPLAY="7019" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="264" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-24 16:12:17.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="489" AD_KEY="6954" AD_DISPLAY="6940" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="266" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-24 16:30:19.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="490" AD_KEY="6975" AD_DISPLAY="6979" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="267" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-24 16:40:35.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="491" AD_KEY="6989" AD_DISPLAY="6983" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="269" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-09-14 15:16:37.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="493" AD_KEY="7026" AD_DISPLAY="7019" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_PrintFormat.IsTableBased='N'" ORDERBYCLAUSE="AD_PrintFormat.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="272" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-01-11 19:09:23.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="101" AD_KEY="109" AD_DISPLAY="116" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Column.AD_Table_ID IN (315,266) AND AD_Column.AD_Reference_ID=25" ORDERBYCLAUSE="AD_Column.ColumnName" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="274" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-02-03 20:44:34.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="416" AD_KEY="5403" AD_DISPLAY="5411" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="275" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-02-09 13:51:05.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="145" AD_KEY="837" AD_DISPLAY="482" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="C_Period.StartDate" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="276" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-02-11 23:36:59.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="155" AD_KEY="528" AD_DISPLAY="522" ISVALUEDISPLAYED="Y" ORDERBYCLAUSE="AD_Org.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="277" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-03-18 17:07:30.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsEmployee='Y' &#xa;AND EXISTS (SELECT * FROM C_BPartner_Location l WHERE C_BPartner.C_BPartner_ID=l.C_BPartner_ID AND l.C_Location_ID IS NOT NULL)&#xa;AND EXISTS (SELECT * FROM AD_User u WHERE C_BPartner.C_BPartner_ID=u.C_BPartner_ID)&#xa;" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="278" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-05-08 06:32:47.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="106" AD_KEY="160" AD_DISPLAY="161" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="284" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-06-19 16:56:44.0" CREATEDBY="0" UPDATED="2006-06-26 21:51:31.0" UPDATEDBY="100" AD_TABLE_ID="105" AD_KEY="155" AD_DISPLAY="156" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_Window.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="286" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-07-21 23:28:34.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="114" AD_KEY="212" AD_DISPLAY="213" ISVALUEDISPLAYED="N" WHERECLAUSE="EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND (bp.IsEmployee='Y' OR bp.IsSalesRep='Y'))" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="290" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-09-03 12:25:34.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="259" AD_KEY="2161" AD_DISPLAY="2169" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="C_Order.DocumentNo" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="295" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-12-14 23:09:22.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="320" AD_KEY="3529" AD_DISPLAY="3810" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="296" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-12-14 23:10:29.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="322" AD_KEY="3555" AD_DISPLAY="3819" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="297" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-12-14 23:11:20.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="326" AD_KEY="3611" AD_DISPLAY="4768" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="298" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-12-14 23:12:21.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="329" AD_KEY="3658" AD_DISPLAY="3669" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="316" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-03-06 00:27:42.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="114" AD_KEY="212" AD_DISPLAY="213" ISVALUEDISPLAYED="N" WHERECLAUSE="(AD_User.AD_Client_ID=0 AND AD_User.AD_User_ID=0) OR EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND (bp.IsEmployee='Y' OR bp.IsSalesRep='Y'))" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="321" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-05-12 12:38:15.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="217" AD_KEY="1501" AD_DISPLAY="1509" ISVALUEDISPLAYED="N" WHERECLAUSE="C_DocType.DocBaseType IN ('SOO', 'POO') AND C_DocType.DocSubTypeSO='RM' AND C_DocType.AD_Client_ID=@#AD_Client_ID@" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="322" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-06-09 16:47:19.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="155" AD_KEY="528" AD_DISPLAY="522" ISVALUEDISPLAYED="Y" WHERECLAUSE="AD_Org.AD_Org_ID&lt;>0" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="323" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-06-10 20:27:03.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="735" AD_KEY="12310" AD_DISPLAY="12323" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="331" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-11-28 13:43:57.0" CREATEDBY="0" UPDATED="2005-08-23 18:21:41.0" UPDATEDBY="100" AD_TABLE_ID="188" AD_KEY="1125" AD_DISPLAY="1135" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_ElementValue.IsActive='Y' &#xa;AND C_ElementValue.C_Element_ID IN (SELECT C_Element_ID FROM C_AcctSchema_Element ase WHERE ase.ElementType='AC' AND ase.AD_Client_ID=@AD_Client_ID@)" ORDERBYCLAUSE="C_ElementValue.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="336" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-04-01 15:58:09.0" CREATEDBY="100" UPDATED="2005-04-01 15:58:26.0" UPDATEDBY="100" AD_TABLE_ID="318" AD_KEY="3484" AD_DISPLAY="3492" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="C_Invoice.DocumentNo" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="337" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-04-01 16:04:24.0" CREATEDBY="100" UPDATED="2005-04-01 16:04:24.0" UPDATEDBY="100" AD_TABLE_ID="319" AD_KEY="3521" AD_DISPLAY="3791" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="M_InOut.DocumentNo" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="341" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-04-26 22:00:26.0" CREATEDBY="100" UPDATED="2005-04-26 22:00:26.0" UPDATEDBY="100" AD_TABLE_ID="417" AD_KEY="5415" AD_DISPLAY="5423" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="343" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-05-08 21:08:51.0" CREATEDBY="100" UPDATED="2005-05-08 21:08:51.0" UPDATEDBY="100" AD_TABLE_ID="335" AD_KEY="5043" AD_DISPLAY="5401" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="345" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-05-14 00:19:24.0" CREATEDBY="100" UPDATED="2006-01-15 13:20:09.0" UPDATEDBY="100" AD_TABLE_ID="776" AD_KEY="13562" AD_DISPLAY="15001" ISVALUEDISPLAYED="Y" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="351" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-05-20 22:42:13.0" CREATEDBY="100" UPDATED="2005-05-20 22:42:13.0" UPDATEDBY="100" AD_TABLE_ID="799" AD_KEY="13924" AD_DISPLAY="13932" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="353" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-07-13 15:43:37.0" CREATEDBY="100" UPDATED="2005-07-13 15:44:07.0" UPDATEDBY="100" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsSalesRep='Y'" ORDERBYCLAUSE="C_BPartner.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="137" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-07 00:00:00.0" CREATEDBY="0" UPDATED="2005-08-23 18:19:07.0" UPDATEDBY="100" AD_TABLE_ID="188" AD_KEY="1125" AD_DISPLAY="1135" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_ElementValue.IsActive='Y' AND C_ElementValue.IsSummary='N' &#xa;AND C_ElementValue.C_Element_ID IN (SELECT C_Element_ID FROM C_AcctSchema_Element ase WHERE ase.ElementType='U2' AND ase.AD_Client_ID=@AD_Client_ID@)" ORDERBYCLAUSE="C_ElementValue.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="399" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2006-10-30 00:00:00.0" CREATEDBY="0" UPDATED="2006-10-30 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="877" AD_KEY="15517" AD_DISPLAY="15983" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="134" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-01 00:00:00.0" CREATEDBY="0" UPDATED="2005-08-23 18:20:05.0" UPDATEDBY="100" AD_TABLE_ID="188" AD_KEY="1125" AD_DISPLAY="1135" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_ElementValue.IsActive='Y' AND C_ElementValue.IsSummary='N' &#xa;AND C_ElementValue.C_Element_ID IN (SELECT C_Element_ID FROM C_AcctSchema_Element ase WHERE ase.ElementType='U1' AND ase.AD_Client_ID=@AD_Client_ID@)" ORDERBYCLAUSE="C_ElementValue.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="132" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-01 00:00:00.0" CREATEDBY="0" UPDATED="2005-08-23 18:20:49.0" UPDATEDBY="100" AD_TABLE_ID="188" AD_KEY="1125" AD_DISPLAY="1135" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_ElementValue.IsActive='Y' AND C_ElementValue.IsSummary='N' &#xa;AND C_ElementValue.C_Element_ID IN (SELECT C_Element_ID FROM C_AcctSchema_Element ase WHERE ase.ElementType='AC' AND ase.AD_Client_ID=@AD_Client_ID@)" ORDERBYCLAUSE="C_ElementValue.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="356" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-08-27 09:56:15.0" CREATEDBY="100" UPDATED="2005-08-27 09:56:15.0" UPDATEDBY="100" AD_TABLE_ID="346" AD_KEY="4069" AD_DISPLAY="4078" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="386" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2006-04-16 17:03:45.0" CREATEDBY="100" UPDATED="2006-04-16 17:03:45.0" UPDATEDBY="100" AD_TABLE_ID="855" AD_KEY="15147" AD_DISPLAY="15155" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="387" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2006-04-16 17:05:03.0" CREATEDBY="100" UPDATED="2006-04-16 17:05:03.0" UPDATEDBY="100" AD_TABLE_ID="866" AD_KEY="15323" AD_DISPLAY="15331" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="389" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2006-06-11 14:37:10.0" CREATEDBY="100" UPDATED="2006-06-11 14:37:10.0" UPDATEDBY="100" AD_TABLE_ID="882" AD_KEY="15592" AD_DISPLAY="15601" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="362" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-10-27 15:37:35.0" CREATEDBY="100" UPDATED="2005-10-27 15:38:42.0" UPDATEDBY="100" AD_TABLE_ID="188" AD_KEY="1125" AD_DISPLAY="1135" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_ElementValue.IsSummary&lt;>'Y'" ORDERBYCLAUSE="C_ElementValue.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="371" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-12-26 13:05:00.0" CREATEDBY="100" UPDATED="2005-12-26 13:05:00.0" UPDATEDBY="100" AD_TABLE_ID="835" AD_KEY="14813" AD_DISPLAY="14821" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="325" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-06-14 23:22:20.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="475" AD_KEY="6581" AD_DISPLAY="6589" ISVALUEDISPLAYED="N" WHERECLAUSE="M_DiscountSchema.DiscountType&lt;>'P'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="327" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2004-08-15 11:24:13.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="111" AD_KEY="203" AD_DISPLAY="204" ISVALUEDISPLAYED="N" WHERECLAUSE="(AD_Language.IsSystemLanguage='Y' OR AD_Language.IsBaseLanguage='Y')" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="352" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2005-05-30 14:39:07.0" CREATEDBY="100" UPDATED="2005-05-30 14:39:07.0" UPDATEDBY="100" AD_TABLE_ID="637" AD_KEY="10269" AD_DISPLAY="10267" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="285" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-07-10 21:23:56.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="612" AD_KEY="9498" AD_DISPLAY="9491" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="271" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-12-09 20:31:34.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="260" AD_KEY="2205" AD_DISPLAY="2214" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="268" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-24 18:16:01.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="493" AD_KEY="7026" AD_DISPLAY="7019" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_PrintFormat.AD_Table_ID=498" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="261" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-04 19:25:06.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="493" AD_KEY="7026" AD_DISPLAY="7019" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_PrintFormat.AD_Table_ID=516" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="262" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-04 19:26:41.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="493" AD_KEY="7026" AD_DISPLAY="7019" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_PrintFormat.AD_Table_ID=496" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="263" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-08-04 19:27:46.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="493" AD_KEY="7026" AD_DISPLAY="7019" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_PrintFormat.AD_Table_ID=500&#xa;" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="1" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-05-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="102" AD_KEY="129" AD_DISPLAY="130" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Reference.ValidationType='D'" ORDERBYCLAUSE="AD_Reference.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="3" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-05-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="101" AD_KEY="109" AD_DISPLAY="116" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_Column.AD_Table_ID,AD_Column.ColumnName" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="4" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-05-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="102" AD_KEY="129" AD_DISPLAY="130" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Reference.ValidationType in ('T','L')" ORDERBYCLAUSE="AD_Reference.ValidationType, AD_Reference.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="100" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-05-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="108" AD_KEY="187" AD_DISPLAY="188" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_Val_Rule.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="102" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2002-05-26 10:19:27.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="109" AD_KEY="6765" AD_DISPLAY="198" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_Message.MsgText" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="105" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-05-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="116" AD_KEY="228" AD_DISPLAY="229" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Menu.IsSummary='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="106" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-05-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="111" AD_KEY="203" AD_DISPLAY="204" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="109" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-06-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="129" AD_KEY="293" AD_DISPLAY="294" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="110" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-06-21 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="114" AD_KEY="212" AD_DISPLAY="213" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_User.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="112" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-06-22 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="141" AD_KEY="457" AD_DISPLAY="458" ISVALUEDISPLAYED="N" WHERECLAUSE="C_Currency.IsEMUMember='N' AND C_Currency.IsActive='Y'" ORDERBYCLAUSE="C_Currency.ISO_Code" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="113" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-06-22 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="155" AD_KEY="528" AD_DISPLAY="522" ISVALUEDISPLAYED="N" WHERECLAUSE="EXISTS (SELECT * FROM AD_OrgInfo WHERE AD_Org.AD_Org_ID=AD_OrgInfo.AD_Org_ID AND AD_OrgInfo.IsSummary='Y')" ORDERBYCLAUSE="AD_Org.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="114" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-06-22 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="146" AD_KEY="485" AD_DISPLAY="486" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="124" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-15 08:45:54.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsSummary='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="128" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-06-29 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="115" AD_KEY="1186" AD_DISPLAY="216" ISVALUEDISPLAYED="N" WHERECLAUSE="AD_Sequence.IsTableID='N'" ORDERBYCLAUSE="AD_Sequence.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="129" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-01 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="112" AD_KEY="207" AD_DISPLAY="208" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="AD_Client.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="130" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-01 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="155" AD_KEY="528" AD_DISPLAY="522" ISVALUEDISPLAYED="Y" WHERECLAUSE="AD_Org.IsSummary='N' AND AD_Org_ID &lt;> 0" ORDERBYCLAUSE="AD_Org.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="133" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-13 17:42:34.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="162" AD_KEY="808" AD_DISPLAY="819" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="136" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-07 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="265" AD_KEY="2463" AD_DISPLAY="2471" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="138" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-15 08:47:00.0" CREATEDBY="0" UPDATED="2005-08-23 18:07:32.0" UPDATEDBY="100" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_BPartner.IsSummary='N' AND C_BPartner.IsActive='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="141" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-07 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="203" AD_KEY="1349" AD_DISPLAY="1356" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_Project.IsSummary='N'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="142" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-08-06 23:29:56.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="316" AD_KEY="3457" AD_DISPLAY="3465" ISVALUEDISPLAYED="N" WHERECLAUSE="C_Activity.IsSummary='N'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="143" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-08-06 23:34:02.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="274" AD_KEY="2570" AD_DISPLAY="2578" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_Campaign.IsSummary='N'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="144" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-07 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="230" AD_KEY="1823" AD_DISPLAY="1831" ISVALUEDISPLAYED="Y" WHERECLAUSE="C_SalesRegion.IsSummary='N'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="145" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-07-07 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="142" AD_KEY="464" AD_DISPLAY="466" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="156" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-09 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="170" AD_KEY="941" AD_DISPLAY="949" ISVALUEDISPLAYED="N" ORDERBYCLAUSE="C_Country.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="157" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-09 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="164" AD_KEY="856" AD_DISPLAY="864" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="158" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-09 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="261" AD_KEY="2240" AD_DISPLAY="2246" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="159" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-23 08:38:59.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="293" AD_KEY="3434" AD_DISPLAY="2960" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="161" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="208" AD_KEY="1402" AD_DISPLAY="1410" ISVALUEDISPLAYED="N" WHERECLAUSE="M_Product.IsSummary='Y'" ORDERBYCLAUSE="M_Product.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="162" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="208" AD_KEY="1402" AD_DISPLAY="1410" ISVALUEDISPLAYED="N" WHERECLAUSE="M_Product.IsSummary='N'" ORDERBYCLAUSE="M_Product.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="163" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="209" AD_KEY="2020" AD_DISPLAY="1776" ISVALUEDISPLAYED="Y" ORDERBYCLAUSE="M_Product_Category.Name" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="166" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="255" AD_KEY="2100" AD_DISPLAY="2108" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="169" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="203" AD_KEY="1349" AD_DISPLAY="1356" ISVALUEDISPLAYED="N" WHERECLAUSE="C_Project.IsSummary='Y'" ORDERBYCLAUSE="C_Project.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="170" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="217" AD_KEY="1501" AD_DISPLAY="1509" ISVALUEDISPLAYED="N" WHERECLAUSE="C_DocType.AD_Client_ID=@#AD_Client_ID@" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="171" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2005-07-24 14:03:31.0" UPDATEDBY="100" AD_TABLE_ID="208" AD_KEY="1402" AD_DISPLAY="213" ISVALUEDISPLAYED="N" WHERECLAUSE="M_Product.IsStocked='Y' AND M_Product.IsSummary='N'" ORDERBYCLAUSE="M_Product.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="172" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-08-10 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="217" AD_KEY="1501" AD_DISPLAY="1509" ISVALUEDISPLAYED="N" WHERECLAUSE="C_DocType.DocBaseType='SOO' AND C_DocType.AD_Client_ID=@#AD_Client_ID@" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="173" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-15 08:43:13.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsCustomer='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="174" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-09-27 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="117" AD_KEY="351" AD_DISPLAY="236" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="175" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-09-27 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="176" AD_KEY="1014" AD_DISPLAY="1746" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="179" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-09-29 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="230" AD_KEY="1823" AD_DISPLAY="1831" ISVALUEDISPLAYED="N" WHERECLAUSE="C_SalesRegion.IsSummary='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="182" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-10-11 00:00:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="188" AD_KEY="1125" AD_DISPLAY="1135" ISVALUEDISPLAYED="Y" ORDERBYCLAUSE="C_ElementValue.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="184" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-09 09:00:57.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="288" AD_KEY="2856" AD_DISPLAY="2864" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="188" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-02-01 22:21:33.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="295" AD_KEY="2987" AD_DISPLAY="2995" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="190" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-22 14:36:23.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="114" AD_KEY="212" AD_DISPLAY="213" ISVALUEDISPLAYED="N" WHERECLAUSE="EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep='Y')&#xa;" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="191" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-22 17:11:10.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="207" AD_KEY="1389" AD_DISPLAY="3012" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="192" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-01-25 16:55:06.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsVendor='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="193" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-01-25 20:37:28.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="297" AD_KEY="3077" AD_DISPLAY="3074" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BankAccount.IsCreditCardAcct='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="197" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-02-06 19:59:52.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="190" AD_KEY="1151" AD_DISPLAY="1152" ISVALUEDISPLAYED="N" WHERECLAUSE="M_Warehouse.AD_Client_ID=@#AD_Client_ID@" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="199" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-02-07 16:41:37.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="295" AD_KEY="2987" AD_DISPLAY="2995" ISVALUEDISPLAYED="N" WHERECLAUSE="M_PriceList_Version.AD_Client_ID=@#AD_Client_ID@" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="200" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-02-12 17:24:00.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="313" AD_KEY="3333" AD_DISPLAY="3341" ISVALUEDISPLAYED="N" WHERECLAUSE="C_Charge.AD_Client_ID=@#AD_Client_ID@" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="206" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-08-06 23:37:41.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="100" AD_KEY="100" AD_DISPLAY="102" ISVALUEDISPLAYED="N" WHERECLAUSE="EXISTS (SELECT * FROM AD_Column c WHERE AD_Table.AD_Table_ID=c.AD_Table_ID AND c.IsActive='Y' AND  c.ColumnName='Posted')" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="211" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-10-15 12:57:25.0" CREATEDBY="0" UPDATED="2005-07-24 14:14:16.0" UPDATEDBY="100" AD_TABLE_ID="208" AD_KEY="1402" AD_DISPLAY="1410" ISVALUEDISPLAYED="N" WHERECLAUSE="M_Product.IsBOM='Y' AND M_Product.IsStocked='Y' AND M_Product.IsSummary='N'" ORDERBYCLAUSE="M_Product.Value" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="223" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-01-17 21:38:56.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="291" AD_KEY="2893" AD_DISPLAY="2902" ISVALUEDISPLAYED="N" WHERECLAUSE="C_BPartner.IsVendor='Y' AND EXISTS (SELECT * FROM M_Product_PO po &#xa;WHERE C_BPartner.C_BPartner_ID=po.C_BPartner_ID)" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="227" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-04-09 14:43:43.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="113" AD_KEY="2027" AD_DISPLAY="2035" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="228" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-04-17 22:27:43.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="440" AD_KEY="5884" AD_DISPLAY="5892" ISVALUEDISPLAYED="N" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="229" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-04-17 23:13:28.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="438" AD_KEY="5856" AD_DISPLAY="5864" ISVALUEDISPLAYED="N" WHERECLAUSE="PA_Achievement.IsSummary='Y'" ENTITYTYPE="D" />
  <AD_REF_TABLE AD_REFERENCE_ID="230" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2001-04-17 23:18:38.0" CREATEDBY="0" UPDATED="2000-01-02 00:00:00.0" UPDATEDBY="0" AD_TABLE_ID="440" AD_KEY="5884" AD_DISPLAY="5892" ISVALUEDISPLAYED="N" WHERECLAUSE="PA_Goal.IsSummary='Y'" ENTITYTYPE="D" />
</data>
